Bill Report

Dataset statistics

Number of variables	20
Number of observations	8954786
Missing cells	94
Missing cells (%)	< 0.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.3 GiB
Average record size in memory	160.0 B

Variable types

DateTime	4
Numeric	11
Text	4
Categorical	1

Alerts

`bill_total_billed` is highly overall correlated with `bill_total_net` and 3 other fields	High correlation
`bill_total_net` is highly overall correlated with `bill_total_billed` and 3 other fields	High correlation
`bill_total_tax` is highly overall correlated with `bill_total_billed` and 3 other fields	High correlation
`payment_amount` is highly overall correlated with `bill_total_billed` and 4 other fields	High correlation
`payment_total_tip` is highly overall correlated with `payment_amount`	High correlation
`sales_revenue_with_tax` is highly overall correlated with `bill_total_billed` and 3 other fields	High correlation
`order_take_out_type_label` is highly imbalanced (61.9%)	Imbalance
`bill_total_billed` is highly skewed (γ1 = 144.4166783)	Skewed
`bill_total_discount_item_level` is highly skewed (γ1 = 149.7226489)	Skewed
`bill_total_gratuity` is highly skewed (γ1 = 479.1136713)	Skewed
`bill_total_net` is highly skewed (γ1 = 134.8548939)	Skewed
`bill_total_tax` is highly skewed (γ1 = 261.6218339)	Skewed
`bill_total_voided` is highly skewed (γ1 = 2929.1235)	Skewed
`order_duration_seconds` is highly skewed (γ1 = 238.195982)	Skewed
`payment_amount` is highly skewed (γ1 = 2048.525811)	Skewed
`payment_total_tip` is highly skewed (γ1 = 2960.142341)	Skewed
`sales_revenue_with_tax` is highly skewed (γ1 = 144.4157221)	Skewed
`bill_uuid` has unique values	Unique
`bill_total_billed` has 229152 (2.6%) zeros	Zeros
`bill_total_discount_item_level` has 8267805 (92.3%) zeros	Zeros
`bill_total_gratuity` has 8748366 (97.7%) zeros	Zeros
`bill_total_net` has 229618 (2.6%) zeros	Zeros
`bill_total_tax` has 1326428 (14.8%) zeros	Zeros
`bill_total_voided` has 8715185 (97.3%) zeros	Zeros
`payment_amount` has 230480 (2.6%) zeros	Zeros
`payment_count` has 213726 (2.4%) zeros	Zeros
`payment_total_tip` has 5270130 (58.9%) zeros	Zeros
`sales_revenue_with_tax` has 229169 (2.6%) zeros	Zeros

Reproduction

Analysis started	2025-02-12 00:06:56.533921
Analysis finished	2025-02-12 00:22:30.077393
Duration	15 minutes and 33.54 seconds
Software version	ydata-profiling vv4.12.2
Download configuration	config.json

bill_paid_at_local
Date

Distinct	5832313
Distinct (%)	65.1%
Missing	0
Missing (%)	0.0%
Memory size	68.3 MiB

Minimum	2024-07-01 00:00:01
Maximum	2025-01-01 21:41:43
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

bill_total_billed
Real number (ℝ)

High correlation Skewed Zeros

Distinct	52348
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	36.748312

Minimum	-5731.5
Maximum	74928.61
Zeros	229152
Zeros (%)	2.6%
Negative	13818
Negative (%)	0.2%
Memory size	68.3 MiB

Quantile statistics

Minimum	-5731.5
5-th percentile	3
Q1	10.44
median	21.89
Q3	44.65
95-th percentile	111
Maximum	74928.61
Range	80660.11
Interquartile range (IQR)	34.21

Descriptive statistics

Standard deviation	83.3765
Coefficient of variation (CV)	2.2688525
Kurtosis	84263.107
Mean	36.748312
Median Absolute Deviation (MAD)	14.27
Skewness	144.41668
Sum	3.2907327 × 10⁸
Variance	6951.6407
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	229152	2.6%
14.75	36083	0.4%
8	33994	0.4%
7	32542	0.4%
6	31031	0.3%
11.3	31014	0.3%
15.5	30194	0.3%
9.04	28185	0.3%
10.17	27950	0.3%
3	27381	0.3%
Other values (52338)	8447260	94.3%

Value	Count	Frequency (%)
-5731.5	2	< 0.1%
-4712.1	1	< 0.1%
-3323.28	1	< 0.1%
-2625	1	< 0.1%
-2433.2	1	< 0.1%
-1200	1	< 0.1%
-1158.49	1	< 0.1%
-1000	1	< 0.1%
-822.01	1	< 0.1%
-773.39	1	< 0.1%

Value	Count	Frequency (%)
74928.61	1	< 0.1%
33928.25	1	< 0.1%
25131.48	1	< 0.1%
23132.39	1	< 0.1%
22606.78	1	< 0.1%
22088.31	1	< 0.1%
21000	1	< 0.1%
20551.26	1	< 0.1%
19866	1	< 0.1%
19021.08	1	< 0.1%

bill_total_discount_item_level
Real number (ℝ)

Skewed Zeros

Distinct	21111
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.84038025

Minimum	-91.64
Maximum	5490.92
Zeros	8267805
Zeros (%)	92.3%
Negative	557
Negative (%)	< 0.1%
Memory size	68.3 MiB

Quantile statistics

Minimum	-91.64
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	2.99
Maximum	5490.92
Range	5582.56
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	9.404221
Coefficient of variation (CV)	11.190436
Kurtosis	52064.222
Mean	0.84038025
Median Absolute Deviation (MAD)	0
Skewness	149.72265
Sum	7525425.3
Variance	88.439374
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	8267805	92.3%
2	25179	0.3%
1	23432	0.3%
3	18672	0.2%
5	17377	0.2%
4	16656	0.2%
6	13106	0.1%
10	11484	0.1%
8	9767	0.1%
1.5	9302	0.1%
Other values (21101)	542006	6.1%

Value	Count	Frequency (%)
-91.64	1	< 0.1%
-74.3	1	< 0.1%
-66.25	1	< 0.1%
-62.84	1	< 0.1%
-59.06	2	< 0.1%
-58.62	2	< 0.1%
-55	1	< 0.1%
-53.6	1	< 0.1%
-53.26	1	< 0.1%
-50.27	1	< 0.1%

Value	Count	Frequency (%)
5490.92	1	< 0.1%
4763.45	1	< 0.1%
4227.21	1	< 0.1%
4182	1	< 0.1%
4152	1	< 0.1%
3624.71	1	< 0.1%
3242.04	1	< 0.1%
3115.35	1	< 0.1%
3050	1	< 0.1%
2973.65	1	< 0.1%

bill_total_gratuity
Real number (ℝ)

Skewed Zeros

Distinct	8527
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.24089563

Minimum	-60
Maximum	11935.53
Zeros	8748366
Zeros (%)	97.7%
Negative	41
Negative (%)	< 0.1%
Memory size	68.3 MiB

Quantile statistics

Minimum	-60
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	11935.53
Range	11995.53
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	8.409234
Coefficient of variation (CV)	34.908205
Kurtosis	517986.54
Mean	0.24089563
Median Absolute Deviation (MAD)	0
Skewness	479.11367
Sum	2157168.8
Variance	70.715217
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	8748366	97.7%
0.32	5527	0.1%
0.15	4679	0.1%
0.64	2297	< 0.1%
0.24	1816	< 0.1%
3.6	1591	< 0.1%
0.45	1336	< 0.1%
0.12	1300	< 0.1%
0.3	1298	< 0.1%
0.48	1166	< 0.1%
Other values (8517)	185410	2.1%

Value	Count	Frequency (%)
-60	1	< 0.1%
-37.8	1	< 0.1%
-19.08	1	< 0.1%
-18.4	1	< 0.1%
-12	1	< 0.1%
-11.79	1	< 0.1%
-11.76	1	< 0.1%
-9.58	1	< 0.1%
-3.87	1	< 0.1%
-3.2	1	< 0.1%

Value	Count	Frequency (%)
11935.53	1	< 0.1%
6005	1	< 0.1%
4029.21	1	< 0.1%
4003.25	1	< 0.1%
4001.2	1	< 0.1%
3402.7	1	< 0.1%
3245	1	< 0.1%
2916.32	1	< 0.1%
2504.6	1	< 0.1%
2492.6	1	< 0.1%

bill_total_net
Real number (ℝ)

High correlation Skewed Zeros

Distinct	39096
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	33.898938

Minimum	-5072.12
Maximum	66308.5
Zeros	229618
Zeros (%)	2.6%
Negative	13499
Negative (%)	0.2%
Memory size	68.3 MiB

Quantile statistics

Minimum	-5072.12
5-th percentile	2.8
Q1	9.63
median	20
Q3	41
95-th percentile	102
Maximum	66308.5
Range	71380.62
Interquartile range (IQR)	31.37

Descriptive statistics

Standard deviation	77.543558
Coefficient of variation (CV)	2.2874923
Kurtosis	71061.104
Mean	33.898938
Median Absolute Deviation (MAD)	13
Skewness	134.85489
Sum	3.0355773 × 10⁸
Variance	6013.0034
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	229618	2.6%
8	87408	1.0%
18	74780	0.8%
10	72169	0.8%
16	69570	0.8%
15	68653	0.8%
5	67514	0.8%
12	64947	0.7%
6	63182	0.7%
7	61035	0.7%
Other values (39086)	8095910	90.4%

Value	Count	Frequency (%)
-5072.12	2	< 0.1%
-4170	1	< 0.1%
-3323.28	1	< 0.1%
-2625	1	< 0.1%
-2342.09	1	< 0.1%
-1200	1	< 0.1%
-1158.49	1	< 0.1%
-1000	1	< 0.1%
-755	1	< 0.1%
-695	1	< 0.1%

Value	Count	Frequency (%)
66308.5	1	< 0.1%
30025	1	< 0.1%
22384.5	1	< 0.1%
22240.25	1	< 0.1%
20253.15	1	< 0.1%
20050	1	< 0.1%
20006	1	< 0.1%
19866	1	< 0.1%
18985	1	< 0.1%
17256	1	< 0.1%

bill_total_tax
Real number (ℝ)

High correlation Skewed Zeros

Distinct	11021
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.8493749

Minimum	-659.38
Maximum	8620.11
Zeros	1326428
Zeros (%)	14.8%
Negative	10194
Negative (%)	0.1%
Memory size	68.3 MiB

Quantile statistics

Minimum	-659.38
5-th percentile	0
Q1	0.46
median	1.44
Q3	3.45
95-th percentile	9.85
Maximum	8620.11
Range	9279.49
Interquartile range (IQR)	2.99

Descriptive statistics

Standard deviation	7.1533854
Coefficient of variation (CV)	2.5105104
Kurtosis	254554.13
Mean	2.8493749
Median Absolute Deviation (MAD)	1.24
Skewness	261.62183
Sum	25515542
Variance	51.170922
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1326428	14.8%
1.3	53326	0.6%
1.04	52435	0.6%
0.65	48969	0.5%
0.9	48135	0.5%
0.2	44161	0.5%
2.08	44076	0.5%
0.52	43785	0.5%
1.17	43043	0.5%
0.91	42729	0.5%
Other values (11011)	7207699	80.5%

Value	Count	Frequency (%)
-659.38	2	< 0.1%
-542.1	1	< 0.1%
-91.11	1	< 0.1%
-88.97	1	< 0.1%
-73.85	1	< 0.1%
-73.42	1	< 0.1%
-72.8	1	< 0.1%
-68.9	1	< 0.1%
-67.01	1	< 0.1%
-60.09	1	< 0.1%

Value	Count	Frequency (%)
8620.11	1	< 0.1%
3903.25	1	< 0.1%
2891.23	1	< 0.1%
2600.78	1	< 0.1%
2038.31	1	< 0.1%
1765.08	1	< 0.1%
1566.26	1	< 0.1%
1505.53	1	< 0.1%
1334.81	1	< 0.1%
1300	1	< 0.1%

bill_total_voided
Real number (ℝ)

Skewed Zeros

Distinct	10798
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.93750928

Minimum	-4501.5
Maximum	1000000
Zeros	8715185
Zeros (%)	97.3%
Negative	624
Negative (%)	< 0.1%
Memory size	68.3 MiB

Quantile statistics

Minimum	-4501.5
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	1000000
Range	1004501.5
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	336.59661
Coefficient of variation (CV)	359.03283
Kurtosis	8699773.9
Mean	0.93750928
Median Absolute Deviation (MAD)	0
Skewness	2929.1235
Sum	8395195
Variance	113297.28
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	8715185	97.3%
8	5293	0.1%
10	4570	0.1%
9	4543	0.1%
16	4454	< 0.1%
12	4278	< 0.1%
6	4047	< 0.1%
5	3942	< 0.1%
15	3707	< 0.1%
7	3702	< 0.1%
Other values (10788)	201065	2.2%

Value	Count	Frequency (%)
-4501.5	1	< 0.1%
-1697	1	< 0.1%
-1665.9	1	< 0.1%
-1215.15	1	< 0.1%
-1173.15	1	< 0.1%
-784.81	1	< 0.1%
-630.49	1	< 0.1%
-538.55	1	< 0.1%
-500	1	< 0.1%
-400	1	< 0.1%

Value	Count	Frequency (%)
1000000	1	< 0.1%
43178.4	1	< 0.1%
37405.34	1	< 0.1%
26407.46	1	< 0.1%
23172.36	1	< 0.1%
21370.88	1	< 0.1%
21274.49	1	< 0.1%
20835	1	< 0.1%
20805.02	1	< 0.1%
20071.6	1	< 0.1%

bill_uuid
Text

Unique

Distinct	8954786
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	68.3 MiB

Length

Max length	49
Median length	49
Mean length	48.990803
Min length	36

Characters and Unicode

Total characters	438702159
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	8954786 ?
Unique (%)	100.0%

Sample

1st row	240701091701~4D63608F-523C-4EFF-9A4F-78D6C44B5159
2nd row	240701133659~3A0BEDE2-E9E5-484D-B909-780E485F0D69
3rd row	240701111931~670EEB85-E939-4924-B92F-C95076B7E930
4th row	240701150558~3D6F473E-D5EF-4BB8-AFAB-30DB2A0764C0
5th row	240701124059~0521794C-51FC-4C30-A368-995CE4DE105F

Value	Count	Frequency (%)
240701111931~670eeb85-e939-4924-b92f-c95076b7e930	1	< 0.1%
241231185507~62c6632e-2957-4f0d-8aff-cf89ca378fb4	1	< 0.1%
241226123511~35605033-f24b-46ed-96cd-5ee5ad0af892	1	< 0.1%
241226123530~8fe0f8fe-8881-4c1a-9e02-b62ee88c17d5	1	< 0.1%
241226135739~19c42fec-33be-4a4c-b1ab-add25a7721c0	1	< 0.1%
241226155336~589994ce-d6cf-46d3-9470-b4fcee070e8f	1	< 0.1%
241226214300~babd37be-35a6-4e9e-850a-467bd2689dca	1	< 0.1%
241227163610~521ce078-d840-46e8-a8a3-8a8e983952bb	1	< 0.1%
241227174057~0a0b75d8-71b8-4625-80d8-91924ba9e18e	1	< 0.1%
241227175419~fdca9a8b-8515-47a8-b438-e95fe1b7177b	1	< 0.1%
Other values (8954776)	8954776	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
4	40995320	9.3%
1	38564892	8.8%
2	38477651	8.8%
-	35819144	8.2%
0	33441331	7.6%
9	24267620	5.5%
8	24253871	5.5%
3	23951068	5.5%
5	22977703	5.2%
7	21778270	5.0%
Other values (14)	134175289	30.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	438702159	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
4	40995320	9.3%
1	38564892	8.8%
2	38477651	8.8%
-	35819144	8.2%
0	33441331	7.6%
9	24267620	5.5%
8	24253871	5.5%
3	23951068	5.5%
5	22977703	5.2%
7	21778270	5.0%
Other values (14)	134175289	30.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	438702159	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
4	40995320	9.3%
1	38564892	8.8%
2	38477651	8.8%
-	35819144	8.2%
0	33441331	7.6%
9	24267620	5.5%
8	24253871	5.5%
3	23951068	5.5%
5	22977703	5.2%
7	21778270	5.0%
Other values (14)	134175289	30.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	438702159	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
4	40995320	9.3%
1	38564892	8.8%
2	38477651	8.8%
-	35819144	8.2%
0	33441331	7.6%
9	24267620	5.5%
8	24253871	5.5%
3	23951068	5.5%
5	22977703	5.2%
7	21778270	5.0%
Other values (14)	134175289	30.6%

business_date
Date

Distinct	184
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	68.3 MiB

Minimum	2024-07-01 00:00:00
Maximum	2024-12-31 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

order_duration_seconds
Real number (ℝ)

Skewed

Distinct	118347
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8790.9683

Minimum	-44
Maximum	2.8941241 × 10⁸
Zeros	122
Zeros (%)	< 0.1%
Negative	2
Negative (%)	< 0.1%
Memory size	68.3 MiB

Quantile statistics

Minimum	-44
5-th percentile	33
Q1	110
median	1159
Q3	3377
95-th percentile	9741
Maximum	2.8941241 × 10⁸
Range	2.8941246 × 10⁸
Interquartile range (IQR)	3267

Descriptive statistics

Standard deviation	398439.78
Coefficient of variation (CV)	45.323766
Kurtosis	89740.817
Mean	8790.9683
Median Absolute Deviation (MAD)	1106
Skewness	238.19598
Sum	7.872124 × 10¹⁰
Variance	1.5875426 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
42	32247	0.4%
43	31866	0.4%
40	31857	0.4%
45	31685	0.4%
46	31684	0.4%
44	31677	0.4%
41	31666	0.4%
39	31576	0.4%
38	31420	0.4%
47	31330	0.3%
Other values (118337)	8637778	96.5%

Value	Count	Frequency (%)
-44	1	< 0.1%
-19	1	< 0.1%
0	122	< 0.1%
1	2160	< 0.1%
2	5564	0.1%
3	4459	< 0.1%
4	6277	0.1%
5	6740	0.1%
6	6043	0.1%
7	5715	0.1%

Value	Count	Frequency (%)
289412413	1	< 0.1%
196826278	1	< 0.1%
190832960	1	< 0.1%
179540675	1	< 0.1%
163422375	1	< 0.1%
162689496	1	< 0.1%
154425999	1	< 0.1%
151728800	1	< 0.1%
150226620	1	< 0.1%
142630398	1	< 0.1%

order_seated_at_local
Date

Distinct	5441306
Distinct (%)	60.8%
Missing	0
Missing (%)	0.0%
Memory size	68.3 MiB

Minimum	2015-10-10 19:13:37
Maximum	2025-01-01 18:57:30
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

order_closed_at_local
Date

Distinct	5803496
Distinct (%)	64.8%
Missing	0
Missing (%)	0.0%
Memory size	68.3 MiB

Minimum	2024-07-01 00:00:01
Maximum	2025-01-01 21:41:43
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

order_take_out_type_label
Categorical

Imbalance

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	68.3 MiB

dinein	7443139
takeout	975989
onlineorder	270192
bartab	247617
delivery	17849

Length

Max length	11
Median length	6
Mean length	6.2638418
Min length	6

Characters and Unicode

Total characters	56091363
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	dinein
2nd row	dinein
3rd row	dinein
4th row	dinein
5th row	dinein

Common Values

Value	Count	Frequency (%)
dinein	7443139	83.1%
takeout	975989	10.9%
onlineorder	270192	3.0%
bartab	247617	2.8%
delivery	17849	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
dinein	7443139	83.1%
takeout	975989	10.9%
onlineorder	270192	3.0%
bartab	247617	2.8%
delivery	17849	0.2%

Most occurring characters

Value	Count	Frequency (%)
n	15426662	27.5%
i	15174319	27.1%
e	8995210	16.0%
d	7731180	13.8%
t	2199595	3.9%
o	1516373	2.7%
a	1471223	2.6%
k	975989	1.7%
u	975989	1.7%
r	805850	1.4%
Other values (4)	818973	1.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	56091363	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
n	15426662	27.5%
i	15174319	27.1%
e	8995210	16.0%
d	7731180	13.8%
t	2199595	3.9%
o	1516373	2.7%
a	1471223	2.6%
k	975989	1.7%
u	975989	1.7%
r	805850	1.4%
Other values (4)	818973	1.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	56091363	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
n	15426662	27.5%
i	15174319	27.1%
e	8995210	16.0%
d	7731180	13.8%
t	2199595	3.9%
o	1516373	2.7%
a	1471223	2.6%
k	975989	1.7%
u	975989	1.7%
r	805850	1.4%
Other values (4)	818973	1.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	56091363	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
n	15426662	27.5%
i	15174319	27.1%
e	8995210	16.0%
d	7731180	13.8%
t	2199595	3.9%
o	1516373	2.7%
a	1471223	2.6%
k	975989	1.7%
u	975989	1.7%
r	805850	1.4%
Other values (4)	818973	1.5%

order_uuid
Text

Distinct	8221819
Distinct (%)	91.8%
Missing	0
Missing (%)	0.0%
Memory size	68.3 MiB

Length

Max length	49
Median length	49
Mean length	48.990803
Min length	36

Characters and Unicode

Total characters	438702159
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	7804409 ?
Unique (%)	87.2%

Sample

1st row	240701091615~EF1C6E91-B6C4-4DF1-8A92-1B024197FEC3
2nd row	240701133212~A4C33BFA-A54F-4627-B0C2-7428427FB5DE
3rd row	240701111717~6074B0AB-2432-484D-BC3F-55CC5D731818
4th row	240701150511~EAA68F41-20ED-4FC7-B902-B0B3878AEC82
5th row	240701123917~27764E1C-7E7F-4293-ABC7-5921310A654A

Value	Count	Frequency (%)
241019211330~7bbb205b-b2c5-4a41-be48-3adbbb373eb1	92	< 0.1%
240914174325~01482558-0947-4341-8662-cf4eb18cc045	52	< 0.1%
240913225853~632e2003-bd52-4c2d-a42d-cbe90c35535a	43	< 0.1%
241018211013~83c159f1-9998-42ae-b8e2-06154a4a495f	39	< 0.1%
240726211619~ce2ffa2c-3bb0-49f9-a695-f3bb0d074c73	38	< 0.1%
241231213143~f495c51e-a537-4a1b-8e16-da97a132d190	36	< 0.1%
241012223955~38741a41-132a-4818-a003-c9dc425e4ed0	33	< 0.1%
241012194904~25c7b69f-c134-421a-ae23-927c922fa034	32	< 0.1%
241108234708~11accc10-5fbc-4559-84f0-73e7a8340afa	31	< 0.1%
240920223808~092fe466-3c2a-46ef-8898-684dce87cd8b	30	< 0.1%
Other values (8221809)	8954360	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
4	40907741	9.3%
1	39112820	8.9%
2	37861492	8.6%
-	35819144	8.2%
0	33250178	7.6%
8	24439114	5.6%
9	24274206	5.5%
3	23813475	5.4%
5	22916348	5.2%
7	22009395	5.0%
Other values (14)	134298246	30.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	438702159	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
4	40907741	9.3%
1	39112820	8.9%
2	37861492	8.6%
-	35819144	8.2%
0	33250178	7.6%
8	24439114	5.6%
9	24274206	5.5%
3	23813475	5.4%
5	22916348	5.2%
7	22009395	5.0%
Other values (14)	134298246	30.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	438702159	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
4	40907741	9.3%
1	39112820	8.9%
2	37861492	8.6%
-	35819144	8.2%
0	33250178	7.6%
8	24439114	5.6%
9	24274206	5.5%
3	23813475	5.4%
5	22916348	5.2%
7	22009395	5.0%
Other values (14)	134298246	30.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	438702159	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
4	40907741	9.3%
1	39112820	8.9%
2	37861492	8.6%
-	35819144	8.2%
0	33250178	7.6%
8	24439114	5.6%
9	24274206	5.5%
3	23813475	5.4%
5	22916348	5.2%
7	22009395	5.0%
Other values (14)	134298246	30.6%

payment_amount
Real number (ℝ)

High correlation Skewed Zeros

Distinct	60807
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	40.638782

Minimum	-5731.5
Maximum	522752.27
Zeros	230480
Zeros (%)	2.6%
Negative	13469
Negative (%)	0.2%
Memory size	68.3 MiB

Quantile statistics

Minimum	-5731.5
5-th percentile	3
Q1	10.97
median	23.47
Q3	48.87
95-th percentile	125.05
Maximum	522752.27
Range	528483.77
Interquartile range (IQR)	37.9

Descriptive statistics

Standard deviation	198.72923
Coefficient of variation (CV)	4.8901375
Kurtosis	5349711.7
Mean	40.638782
Median Absolute Deviation (MAD)	15.56
Skewness	2048.5258
Sum	3.6391159 × 10⁸
Variance	39493.307
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	230480	2.6%
14.75	33121	0.4%
7	28667	0.3%
6	27963	0.3%
8	27770	0.3%
15.5	26348	0.3%
3	25961	0.3%
5	23937	0.3%
11.3	23790	0.3%
12	23258	0.3%
Other values (60797)	8483491	94.7%

Value	Count	Frequency (%)
-5731.5	2	< 0.1%
-4712.1	1	< 0.1%
-3323.28	1	< 0.1%
-2625	1	< 0.1%
-2433.2	1	< 0.1%
-1200	1	< 0.1%
-1158.49	1	< 0.1%
-1000	1	< 0.1%
-822.01	1	< 0.1%
-773.39	1	< 0.1%

Value	Count	Frequency (%)
522752.27	1	< 0.1%
86864.14	1	< 0.1%
39933.25	1	< 0.1%
29134.73	1	< 0.1%
27161.6	1	< 0.1%
26607.98	1	< 0.1%
25333.31	1	< 0.1%
25050.63	1	< 0.1%
24348.26	1	< 0.1%
23786.14	1	< 0.1%

payment_count
Real number (ℝ)

Zeros

Distinct	25
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.98444251

Minimum	0
Maximum	41
Zeros	213726
Zeros (%)	2.4%
Negative	0
Negative (%)	0.0%
Memory size	68.3 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	1
Maximum	41
Range	41
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.1926432
Coefficient of variation (CV)	0.19568761
Kurtosis	536.27749
Mean	0.98444251
Median Absolute Deviation (MAD)	0
Skewness	4.3116816
Sum	8815472
Variance	0.037111402
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=25)

Value	Count	Frequency (%)
1	8678322	96.9%
0	213726	2.4%
2	55558	0.6%
3	4949	0.1%
4	1226	< 0.1%
5	538	< 0.1%
6	210	< 0.1%
7	111	< 0.1%
8	52	< 0.1%
9	29	< 0.1%
Other values (15)	65	< 0.1%

Value	Count	Frequency (%)
0	213726	2.4%
1	8678322	96.9%
2	55558	0.6%
3	4949	0.1%
4	1226	< 0.1%
5	538	< 0.1%
6	210	< 0.1%
7	111	< 0.1%
8	52	< 0.1%
9	29	< 0.1%

Value	Count	Frequency (%)
41	1	< 0.1%
29	1	< 0.1%
27	1	< 0.1%
23	1	< 0.1%
22	2	< 0.1%
20	1	< 0.1%
19	1	< 0.1%
18	2	< 0.1%
17	2	< 0.1%
16	3	< 0.1%

payment_total_tip
Real number (ℝ)

High correlation Skewed Zeros

Distinct	12894
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.6542116

Minimum	-253.14
Maximum	522715.64
Zeros	5270130
Zeros (%)	58.9%
Negative	104
Negative (%)	< 0.1%
Memory size	68.3 MiB

Quantile statistics

Minimum	-253.14
5-th percentile	0
Q1	0
median	0
Q3	4.07
95-th percentile	16.81
Maximum	522715.64
Range	522968.78
Interquartile range (IQR)	4.07

Descriptive statistics

Standard deviation	175.31856
Coefficient of variation (CV)	47.977125
Kurtosis	8824410.7
Mean	3.6542116
Median Absolute Deviation (MAD)	0
Skewness	2960.1423
Sum	32722683
Variance	30736.599
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5270130	58.9%
5	176041	2.0%
2	148820	1.7%
10	139597	1.6%
1	128279	1.4%
3	101440	1.1%
4	70049	0.8%
20	58749	0.7%
6	57866	0.6%
8	49234	0.5%
Other values (12884)	2754581	30.8%

Value	Count	Frequency (%)
-253.14	1	< 0.1%
-207.36	1	< 0.1%
-198.42	1	< 0.1%
-189.5	1	< 0.1%
-179.9	1	< 0.1%
-129.8	1	< 0.1%
-101.7	1	< 0.1%
-99	1	< 0.1%
-83.88	1	< 0.1%
-79.7	1	< 0.1%

Value	Count	Frequency (%)
522715.64	1	< 0.1%
23762.38	1	< 0.1%
17668.02	1	< 0.1%
11097.36	1	< 0.1%
5180.16	1	< 0.1%
4350.09	1	< 0.1%
4050.63	1	< 0.1%
3797	1	< 0.1%
3080	1	< 0.1%
2940	1	< 0.1%

sales_revenue_with_tax
Real number (ℝ)

High correlation Skewed Zeros

Distinct	52346
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	36.749018

Minimum	-5731.5
Maximum	74928.61
Zeros	229169
Zeros (%)	2.6%
Negative	13817
Negative (%)	0.2%
Memory size	68.3 MiB

Quantile statistics

Minimum	-5731.5
5-th percentile	3
Q1	10.44
median	21.89
Q3	44.65
95-th percentile	111
Maximum	74928.61
Range	80660.11
Interquartile range (IQR)	34.21

Descriptive statistics

Standard deviation	83.37668
Coefficient of variation (CV)	2.2688138
Kurtosis	84262.373
Mean	36.749018
Median Absolute Deviation (MAD)	14.27
Skewness	144.41572
Sum	3.2907959 × 10⁸
Variance	6951.6707
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	229169	2.6%
14.75	36083	0.4%
8	33994	0.4%
7	32542	0.4%
6	31031	0.3%
11.3	31014	0.3%
15.5	30194	0.3%
9.04	28185	0.3%
10.17	27950	0.3%
3	27381	0.3%
Other values (52336)	8447243	94.3%

Value	Count	Frequency (%)
-5731.5	2	< 0.1%
-4712.1	1	< 0.1%
-3323.28	1	< 0.1%
-2625	1	< 0.1%
-2433.2	1	< 0.1%
-1200	1	< 0.1%
-1158.49	1	< 0.1%
-1000	1	< 0.1%
-822.01	1	< 0.1%
-773.39	1	< 0.1%

Value	Count	Frequency (%)
74928.61	1	< 0.1%
33928.25	1	< 0.1%
25131.48	1	< 0.1%
23132.39	1	< 0.1%
22606.78	1	< 0.1%
22088.31	1	< 0.1%
21000	1	< 0.1%
20551.26	1	< 0.1%
19866	1	< 0.1%
19021.08	1	< 0.1%

venue_xref_id
Text

Distinct	601
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	68.3 MiB

Length

Max length	64
Median length	64
Mean length	64
Min length	64

Characters and Unicode

Total characters	573106304
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	39e5b4830d4d9c14db7368a95b65d5463ea3d09520373723430c03a5a453b5df
2nd row	39e5b4830d4d9c14db7368a95b65d5463ea3d09520373723430c03a5a453b5df
3rd row	39e5b4830d4d9c14db7368a95b65d5463ea3d09520373723430c03a5a453b5df
4th row	39e5b4830d4d9c14db7368a95b65d5463ea3d09520373723430c03a5a453b5df
5th row	39e5b4830d4d9c14db7368a95b65d5463ea3d09520373723430c03a5a453b5df

Value	Count	Frequency (%)
5e8a21ead84851c212c2cae58849de4d37bc0babfcab05ceff51350412eb3e94	86044	1.0%
6c4ddbba39d1529689be33c4769223b1194ba2dcb9e20f266d18face3279d00a	80194	0.9%
a7de7d703442f619ab305b7752fd215d85b28bad1dba9f01715d38fec9ce0efb	78213	0.9%
1fba23fbdd499646399a75417304d971f5fdea72bce5ba4b0d9e6086ac093892	75070	0.8%
68e559beb80a2ae3cbdbf07043ebf35fbbccd85494216a2f32b31da76ece5ac0	74152	0.8%
5dc459c71f4739c3dbd5872b4d442295864cf5715f704b19e02e1a581453561a	72908	0.8%
92128c7fc22f3f685e9914450a0bd855e258aafff9351663260b080a4a7c5188	68561	0.8%
6afc5202235f3b742e6482c94536ab8462f6022054eccb0c6d5630c211c0a7fe	66480	0.7%
5ece4507d7aec26fdcca66082fcc77457f79cea602c1a82122c7ea496d37c493	65448	0.7%
3c5a0e6460177d012e070306ba429335066823de1e25aa1ffbd3df7966cacd81	64779	0.7%
Other values (591)	8222937	91.8%

Most occurring characters

Value	Count	Frequency (%)
2	38593238	6.7%
c	37575268	6.6%
e	37459095	6.5%
0	36401005	6.4%
f	36188145	6.3%
a	35852502	6.3%
d	35836090	6.3%
3	35746675	6.2%
b	35664639	6.2%
6	35388616	6.2%
Other values (6)	208401031	36.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	573106304	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
2	38593238	6.7%
c	37575268	6.6%
e	37459095	6.5%
0	36401005	6.4%
f	36188145	6.3%
a	35852502	6.3%
d	35836090	6.3%
3	35746675	6.2%
b	35664639	6.2%
6	35388616	6.2%
Other values (6)	208401031	36.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	573106304	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
2	38593238	6.7%
c	37575268	6.6%
e	37459095	6.5%
0	36401005	6.4%
f	36188145	6.3%
a	35852502	6.3%
d	35836090	6.3%
3	35746675	6.2%
b	35664639	6.2%
6	35388616	6.2%
Other values (6)	208401031	36.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	573106304	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
2	38593238	6.7%
c	37575268	6.6%
e	37459095	6.5%
0	36401005	6.4%
f	36188145	6.3%
a	35852502	6.3%
d	35836090	6.3%
3	35746675	6.2%
b	35664639	6.2%
6	35388616	6.2%
Other values (6)	208401031	36.4%

waiter_uuid
Text

Distinct	9162
Distinct (%)	0.1%
Missing	94
Missing (%)	< 0.1%
Memory size	68.3 MiB

Length

Max length	49
Median length	49
Mean length	47.36324
Min length	20

Characters and Unicode

Total characters	424123230
Distinct characters	33
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	341 ?
Unique (%)	< 0.1%

Sample

1st row	161027134744~719D0E09-5CA7-442A-B9FA-BBBF4083B4FD
2nd row	161027134744~719D0E09-5CA7-442A-B9FA-BBBF4083B4FD
3rd row	161027134744~719D0E09-5CA7-442A-B9FA-BBBF4083B4FD
4th row	161027134744~719D0E09-5CA7-442A-B9FA-BBBF4083B4FD
5th row	161027134744~719D0E09-5CA7-442A-B9FA-BBBF4083B4FD

Value	Count	Frequency (%)
190405092446~8646fe39-600c-4318-bea7-0a31d4082914	431432	4.8%
220405145647~93ca8d12-f48a-44ec-bf83-2674a4dc6094	73563	0.8%
200122200826~9afddbd1-59a4-4016-ad66-830100e21632	43295	0.5%
220808130537~4ff8785d-4a7b-49ff-a7fe-b8551b6591d0	38721	0.4%
200217111829~15f6aab8-87ad-4e90-a5ca-f6ed08fc1e4f	37727	0.4%
150101000000~99c97c5b-82ae-48b5-a578-cc528ee0c57c	37421	0.4%
cc66dfde-4181-46f5-a04d-d14424650700	37380	0.4%
201209123916~356b9122-4031-4a51-886f-8dcea9d8afc5	36170	0.4%
230711173726~12a0de3a-7ef0-4477-bbee-4b422343fab9	33057	0.4%
220528101742~8c27e6e6-4320-45ad-aea9-fdb28a8364cd	31541	0.4%
Other values (9152)	8154385	91.1%

Most occurring characters

Value	Count	Frequency (%)
4	36033458	8.5%
-	35818720	8.4%
0	35781314	8.4%
1	35628843	8.4%
2	33658061	7.9%
3	24410284	5.8%
9	23365754	5.5%
5	23032400	5.4%
8	23003734	5.4%
6	21311769	5.0%
Other values (23)	132078893	31.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	424123230	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
4	36033458	8.5%
-	35818720	8.4%
0	35781314	8.4%
1	35628843	8.4%
2	33658061	7.9%
3	24410284	5.8%
9	23365754	5.5%
5	23032400	5.4%
8	23003734	5.4%
6	21311769	5.0%
Other values (23)	132078893	31.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	424123230	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
4	36033458	8.5%
-	35818720	8.4%
0	35781314	8.4%
1	35628843	8.4%
2	33658061	7.9%
3	24410284	5.8%
9	23365754	5.5%
5	23032400	5.4%
8	23003734	5.4%
6	21311769	5.0%
Other values (23)	132078893	31.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	424123230	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
4	36033458	8.5%
-	35818720	8.4%
0	35781314	8.4%
1	35628843	8.4%
2	33658061	7.9%
3	24410284	5.8%
9	23365754	5.5%
5	23032400	5.4%
8	23003734	5.4%
6	21311769	5.0%
Other values (23)	132078893	31.1%

	bill_total_billed	bill_total_discount_item_level	bill_total_gratuity	bill_total_net	bill_total_tax	bill_total_voided	order_duration_seconds	order_take_out_type_label	payment_amount	payment_count	payment_total_tip	sales_revenue_with_tax
bill_total_billed	1.000	-0.076	0.077	0.999	0.779	-0.058	0.478	0.004	0.995	0.259	0.457	1.000
bill_total_discount_item_level	-0.076	1.000	-0.003	-0.076	-0.061	-0.001	0.107	0.006	-0.073	-0.174	-0.017	-0.076
bill_total_gratuity	0.077	-0.003	1.000	0.077	0.078	0.006	0.082	0.003	0.090	0.026	0.023	0.077
bill_total_net	0.999	-0.076	0.077	1.000	0.756	-0.058	0.473	0.004	0.994	0.259	0.454	0.999
bill_total_tax	0.779	-0.061	0.078	0.756	1.000	-0.052	0.445	0.005	0.781	0.225	0.419	0.779
bill_total_voided	-0.058	-0.001	0.006	-0.058	-0.052	1.000	0.103	0.000	-0.057	-0.372	-0.017	-0.058
order_duration_seconds	0.478	0.107	0.082	0.473	0.445	0.103	1.000	0.002	0.492	-0.048	0.351	0.478
order_take_out_type_label	0.004	0.006	0.003	0.004	0.005	0.000	0.002	1.000	0.001	0.001	0.000	0.004
payment_amount	0.995	-0.073	0.090	0.994	0.781	-0.057	0.492	0.001	1.000	0.259	0.521	0.995
payment_count	0.259	-0.174	0.026	0.259	0.225	-0.372	-0.048	0.001	0.259	1.000	0.118	0.259
payment_total_tip	0.457	-0.017	0.023	0.454	0.419	-0.017	0.351	0.000	0.521	0.118	1.000	0.457
sales_revenue_with_tax	1.000	-0.076	0.077	0.999	0.779	-0.058	0.478	0.004	0.995	0.259	0.457	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

	bill_paid_at_local	bill_total_billed	bill_total_net	bill_total_tax	bill_uuid	business_date	order_duration_seconds	order_seated_at_local	order_closed_at_local	order_take_out_type_label	order_uuid	payment_amount	payment_count	payment_total_tip	sales_revenue_with_tax	venue_xref_id	waiter_uuid
0	2024-07-01 09:17:01	21.81	19.30	2.51	240701091701~4D63608F-523C-4EFF-9A4F-78D6C44B5159	2024-07-01	46	2024-07-01 09:16:15	2024-07-01 09:17:01	dinein	240701091615~EF1C6E91-B6C4-4DF1-8A92-1B024197FEC3	21.81	1	0.0	21.81	39e5b4830d4d9c14db7368a95b65d5463ea3d09520373723430c03a5a453b5df	161027134744~719D0E09-5CA7-442A-B9FA-BBBF4083B4FD
1	2024-07-01 13:37:00	48.95	43.32	5.63	240701133659~3A0BEDE2-E9E5-484D-B909-780E485F0D69	2024-07-01	288	2024-07-01 13:32:12	2024-07-01 13:37:00	dinein	240701133212~A4C33BFA-A54F-4627-B0C2-7428427FB5DE	48.95	1	0.0	48.95	39e5b4830d4d9c14db7368a95b65d5463ea3d09520373723430c03a5a453b5df	161027134744~719D0E09-5CA7-442A-B9FA-BBBF4083B4FD
2	2024-07-01 11:19:32	26.94	23.84	3.10	240701111931~670EEB85-E939-4924-B92F-C95076B7E930	2024-07-01	135	2024-07-01 11:17:17	2024-07-01 11:19:32	dinein	240701111717~6074B0AB-2432-484D-BC3F-55CC5D731818	26.94	1	0.0	26.94	39e5b4830d4d9c14db7368a95b65d5463ea3d09520373723430c03a5a453b5df	161027134744~719D0E09-5CA7-442A-B9FA-BBBF4083B4FD
3	2024-07-01 15:05:59	3.96	3.77	0.19	240701150558~3D6F473E-D5EF-4BB8-AFAB-30DB2A0764C0	2024-07-01	48	2024-07-01 15:05:11	2024-07-01 15:05:59	dinein	240701150511~EAA68F41-20ED-4FC7-B902-B0B3878AEC82	3.96	1	0.0	3.96	39e5b4830d4d9c14db7368a95b65d5463ea3d09520373723430c03a5a453b5df	161027134744~719D0E09-5CA7-442A-B9FA-BBBF4083B4FD
4	2024-07-01 12:41:00	3.36	3.20	0.16	240701124059~0521794C-51FC-4C30-A368-995CE4DE105F	2024-07-01	103	2024-07-01 12:39:17	2024-07-01 12:41:00	dinein	240701123917~27764E1C-7E7F-4293-ABC7-5921310A654A	3.36	1	0.0	3.36	39e5b4830d4d9c14db7368a95b65d5463ea3d09520373723430c03a5a453b5df	161027134744~719D0E09-5CA7-442A-B9FA-BBBF4083B4FD
5	2024-07-01 10:01:55	16.36	14.48	1.88	240701100155~9B70DD97-2C09-4EF1-9C7B-8076D84E062B	2024-07-01	84	2024-07-01 10:00:31	2024-07-01 10:01:55	dinein	240701100031~8AE5F668-E818-4830-AE73-509C16EA7741	16.36	1	0.0	16.36	39e5b4830d4d9c14db7368a95b65d5463ea3d09520373723430c03a5a453b5df	161027134744~719D0E09-5CA7-442A-B9FA-BBBF4083B4FD
6	2024-07-01 12:23:46	17.42	15.42	2.00	240701122346~091CE8CA-7135-43F7-8D67-A5261BD30CDA	2024-07-01	142	2024-07-01 12:21:24	2024-07-01 12:23:46	dinein	240701122124~13DBD4D5-2C64-48C8-80D5-9E9FC3D116DF	17.42	1	0.0	17.42	39e5b4830d4d9c14db7368a95b65d5463ea3d09520373723430c03a5a453b5df	161027134744~719D0E09-5CA7-442A-B9FA-BBBF4083B4FD
7	2024-07-01 11:59:07	25.11	22.22	2.89	240701115907~074476EF-C6EA-49A0-B76E-E99264E1D1A6	2024-07-01	131	2024-07-01 11:56:56	2024-07-01 11:59:07	dinein	240701115656~D9D66137-AFBB-488F-91A3-3EDA3207A8F2	25.11	1	0.0	25.11	39e5b4830d4d9c14db7368a95b65d5463ea3d09520373723430c03a5a453b5df	161027134744~719D0E09-5CA7-442A-B9FA-BBBF4083B4FD
8	2024-07-01 15:37:40	4.97	4.40	0.57	240701153740~40A8D7C4-425A-44DB-98FF-E663A12E19F6	2024-07-01	19	2024-07-01 15:37:21	2024-07-01 15:37:40	dinein	240701153721~72BC36E3-4E0A-47B7-AE1D-892071933B1C	4.97	1	0.0	4.97	39e5b4830d4d9c14db7368a95b65d5463ea3d09520373723430c03a5a453b5df	161027134744~719D0E09-5CA7-442A-B9FA-BBBF4083B4FD
9	2024-07-01 16:20:10	19.00	19.00	0.00	240701162010~01A577B5-25CB-4908-AF54-73B5428FD83B	2024-07-01	716	2024-07-01 16:08:14	2024-07-01 16:20:10	dinein	240701160814~B6D53396-87A5-4AE9-A83B-B1A059AE4A83	25.00	1	6.0	19.00	39e5b4830d4d9c14db7368a95b65d5463ea3d09520373723430c03a5a453b5df	161027134744~719D0E09-5CA7-442A-B9FA-BBBF4083B4FD

	bill_paid_at_local	bill_total_billed	bill_total_discount_item_level	bill_total_net	bill_uuid	business_date	order_duration_seconds	order_seated_at_local	order_closed_at_local	order_take_out_type_label	order_uuid	payment_amount	payment_count	sales_revenue_with_tax	venue_xref_id	waiter_uuid
8954776	2024-12-27 17:40:58	24.98	0.00	24.98	241227174057~0A0B75D8-71B8-4625-80D8-91924BA9E18E	2024-12-27	507	2024-12-27 17:32:31	2024-12-27 17:40:58	takeout	241227173231~6B94AD74-4C11-4977-8A1D-2CD15C39AB36	24.98	1	24.98	45f1736264898588301e2983fd2de6969a9af33aa0f6f8ec588d258c1971c817	221116163611~F844A24E-44E8-40F2-B6D0-073FF805DBF7
8954777	2024-12-27 17:54:19	78.43	0.00	78.43	241227175419~FDCA9A8B-8515-47A8-B438-E95FE1B7177B	2024-12-27	3853	2024-12-27 16:50:06	2024-12-27 17:54:19	dinein	241227165006~8559E840-33DD-47EA-844E-211E68ED17A3	78.43	1	78.43	45f1736264898588301e2983fd2de6969a9af33aa0f6f8ec588d258c1971c817	230202164435~D6FB6D1F-F2E2-4DB2-8278-59AAFF09A7F4
8954778	2024-12-27 21:32:43	108.90	0.00	108.90	241227213243~3465F212-5737-4B4A-9FE4-B528E630C08D	2024-12-27	3859	2024-12-27 20:28:24	2024-12-27 21:32:43	dinein	241227202824~BB60AF10-4446-4659-9F0C-B7E3942B62EA	108.90	1	108.90	45f1736264898588301e2983fd2de6969a9af33aa0f6f8ec588d258c1971c817	230202164435~D6FB6D1F-F2E2-4DB2-8278-59AAFF09A7F4
8954779	2024-12-28 19:58:00	75.42	0.00	75.42	241228195800~416C102D-5E2B-47B7-9EA3-4D4D56367D96	2024-12-28	3087	2024-12-28 19:06:33	2024-12-28 19:58:00	dinein	241228190633~A3D5144B-B4E1-4855-8718-B7995717B526	75.42	1	75.42	45f1736264898588301e2983fd2de6969a9af33aa0f6f8ec588d258c1971c817	230522185246~9369CFD3-1EED-48B1-A116-F8A4F6B66FC6
8954780	2024-12-28 20:38:29	99.92	0.00	99.92	241228203829~D10C3768-50E1-4E52-8F0A-F5CBA575A514	2024-12-28	7419	2024-12-28 18:34:50	2024-12-28 20:38:29	dinein	241228183450~DAE45042-47AA-4DF0-A580-4EB72ACB8763	99.92	1	99.92	45f1736264898588301e2983fd2de6969a9af33aa0f6f8ec588d258c1971c817	230522185246~9369CFD3-1EED-48B1-A116-F8A4F6B66FC6
8954781	2024-12-29 20:32:54	82.42	0.00	82.42	241229203254~464AA06D-F986-4C51-8A53-A7B8362072D6	2024-12-29	4382	2024-12-29 19:19:52	2024-12-29 20:32:54	dinein	241229191952~96F91DE2-5ECC-4AC9-9228-B0741F3494B1	82.42	1	82.42	45f1736264898588301e2983fd2de6969a9af33aa0f6f8ec588d258c1971c817	220831171122~1455DBA8-211C-4281-BF27-8698365CA3EB
8954782	2024-12-30 20:36:19	87.92	0.00	87.92	241230203619~37348A86-98D1-4113-8EDD-06A3CF61A85B	2024-12-30	5244	2024-12-30 19:08:55	2024-12-30 20:36:19	dinein	241230190855~BB4604F2-B7BA-487A-99AF-7AEB77CA3EEC	87.92	1	87.92	45f1736264898588301e2983fd2de6969a9af33aa0f6f8ec588d258c1971c817	230522185246~9369CFD3-1EED-48B1-A116-F8A4F6B66FC6
8954783	2024-12-31 14:24:23	51.96	0.00	51.96	241231142423~9D2E9295-9E59-4E76-8242-D230C9FD2494	2024-12-31	963	2024-12-31 14:08:20	2024-12-31 14:24:23	takeout	241231140820~4D531668-3D68-4789-A1DB-BE324D4583D5	51.96	1	51.96	45f1736264898588301e2983fd2de6969a9af33aa0f6f8ec588d258c1971c817	161216233231~64B016BA-D9BA-49C7-8726-4BCB6516A11D
8954784	2024-12-31 17:00:34	49.35	11.59	49.35	241231170034~A9B4401D-26DC-4FC5-A4F9-0261D950DB3B	2024-12-31	59	2024-12-31 16:59:35	2024-12-31 17:00:34	takeout	241231165935~27989697-086C-4F7C-8AB2-8C0A8B2CF3A7	49.35	1	49.35	45f1736264898588301e2983fd2de6969a9af33aa0f6f8ec588d258c1971c817	230522185246~9369CFD3-1EED-48B1-A116-F8A4F6B66FC6
8954785	2024-12-31 18:55:07	88.42	0.00	88.42	241231185507~62C6632E-2957-4F0D-8AFF-CF89CA378FB4	2024-12-31	6556	2024-12-31 17:05:51	2024-12-31 18:55:07	dinein	241231170551~4DEE5611-B193-40FB-858B-0650CE2F7259	88.42	1	88.42	45f1736264898588301e2983fd2de6969a9af33aa0f6f8ec588d258c1971c817	230522185246~9369CFD3-1EED-48B1-A116-F8A4F6B66FC6

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample